The records in the groups are not sorted due to no sort method selected.
Cause:
In Query Design view, the fields in the query grid do not have a sort method selected by default.
Solution:
In the Query Design view, select the desired sort method from the 'Sort' drop-down list for the desired fields.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query in the list box. (The selected query is highlighted.)
4) Click 'Design'. (The query appears in Design view.)
5) Click in the 'Sort' cell of the desired field. (A down arrow appears.)
6) Click down arrow. (A drop-down list appears.)
7) Do one of the following to select a sort method:
a) Select 'Ascending' from the 'Sort' drop-down list to sort the records in ascending order.
b) Select 'Descending' from the 'Sort' drop-down list to sort the records in descending order.
8) Repeat steps 5) through 7) for each additional field to be sorted.
9) Select the 'File' menu and select 'Save' to save changes to the query.
10) Select the 'Query' menu and select 'Run' to view the results of the query.
